
create external table  jms_dm.dm_site_wrong_sum_dt
(
    date_time             string comment ''日期'',
    agent_code             string comment ''代理区code'',
    agent_name       string comment ''代理区name'',
    fran_code            string comment ''加盟商编码'',
    fran_name             string comment ''加盟商名称'',
    taking_site_code     string comment ''揽收网点code'',
    taking_site_name      string comment ''揽收网点name'',
    total_num          bigint comment ''网点总量'',
    wrong_num   bigint comment ''始发中心name''
)
    COMMENT ''网点错分汇总''
    PARTITIONED BY ( dt STRING COMMENT ''扫描时间'')
    STORED AS PARQUET
    LOCATION ''/dw/hive/jms_dm.db/external/dm_site_wrong_sum_dt''
;
